

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<script type="text/javascript" src="helpman_topicinit.js"></script>

<title>PostgreSQL Data Repository [Enterprise Architect User Guide]</title>

<meta name="keywords" content="Enterprise Architect, Sparx Systems, UML, Model File,Model File Connect To PostgreSQL Data Repository,Connect,Connect To PostgreSQL Data Repository,PostgreSQL,PostgreSQL Data Repository, Connect To,Data Repository,Data Repository PostgreSQL, Connect To,Lazy Loading,Lazy Loading For PostgreSQL Data Repository,WAN Optimization,WAN Optimization For PostgreSQL Data Repository">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta http-equiv="Content-Style-Type" content="text/css" />

<link type="text/css" href="default.css" rel="stylesheet" />
<style type="text/css">
  A, A:Visited
  {
    color: #00F;
  }

  A:Active, A:Hover
  {
    color: #F00;
  }

  OL
  {
    margin: 5px 0 5px 48px;
  }

  UL
  {
    margin-bottom: 3px;
    margin-top: 0;
  }

  #nsr
  {
    background-color: #D4DFFF;
  }

  #nsr A
  {
    text-decoration: none;
  }

  #mainbody
  {
    padding: 8px;
  }

  .p_BodyText
  {
    padding: 5px 0;
  }
</style>



<style type="text/css" media="screen">
  BODY
  {
    background-color: #FFFFFF;
  }

  #nsr
  {
    padding: 6px 6px 0 6px;
    border-bottom: none;
    vertical-align: top;
    z-index: 2;
    visibility: visible;
    left: 0;
    top: 0;
    position: absolute;
  }

  #mainbody
  {
    left: 0;
    top: 0;
    margin: 0;
    position: absolute;
    padding: 10px;
    overflow: auto;
    height: 100%;
    z-index: 1;
    background-repeat: no-repeat;
    background-position: bottom right;
    background-attachment: fixed;
  }
</style>

<style type="text/css" media="print">
  #nsr
  {
    visibility: none;
  }

  #mainbody
  {
    overflow: visible;
  }
</style>
<script type="text/javascript" language="JavaScript" src="nonscroll.js"></script>

</head>
<body scroll="no">

<div id="page">



        <div id="content">
          <div id="content-inner">
          



  
          <div id="nsr">
            <table border="0" cellspacing="0" cellpadding="4" width="100%">
              <tr valign="top">
                <td align="left">
  


                  <p class="p_Heading1"><span class="f_Heading1">PostgreSQL Data Repository</span></p>



  
                </td>
                <td align="right">
                  <a href="introduction.htm" onmouseover="document.images.main.src='button_main_h.gif'" onmouseout="document.images.main.src='button_main.gif'">
                    <img name="main" src="button_main.gif" border=0 alt="Return to Introduction">
                  </a>&nbsp;
    
                  <a href="connecttoaoracle9idatarep.htm" onmouseover="document.images.prev.src='button_prev_h.gif'" onmouseout="document.images.prev.src='button_prev.gif'">
                    <img name=prev src="button_prev.gif" border=0 alt="Previous page" />
                  </a>&nbsp;
    
    
    
                  <a href="connecttoanadaptiveserver.htm" onmouseover="document.images.next.src='button_next_h.gif'" onmouseout="document.images.next.src='button_next.gif'">
                    <img name=next src="button_next.gif" border=0 alt="Next page" />
                  </a>
    
    
                </td>
              </tr>
            </table>
          </div>
          <div id="mainbody">
  


                <div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 5px 0px 5px 13px;"><table cellspacing="0" cellpadding="2" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:bottom;">
<td valign="bottom" width="955" bgcolor="#efeff7" style="width:955px; background-color:#efeff7;"><p class="p_TiporNote" style="border-top: none; border-right: none; border-left: none;"><span class="f_TiporNote">Note:</span></p>
</td>
</tr>
<tr style="text-align:left;">
<td width="955" bgcolor="#f7f7ff" style="width:955px; background-color:#f7f7ff;"><p class="p_TiporNoteText"><span class="f_TiporNoteText">This feature is available in the </span><span class="f_TiporNoteText">Corporate, Business and Software Engineering, System Engineering and Ultimate editions</span><span class="f_TiporNoteText">.</span></p>
</td>
</tr>
</table>
</div>
<p class="p_BodyText"><span class="f_BodyText">In order to use a PostgreSQL data repository, you must connect to it in Enterprise Architect first. Before connecting to the repository, you must have <a href="setupapostgresqlodbcdriver.htm">set up a PostgreSQL ODBC driver</a>. To connect to a PostgreSQL data repository in Enterprise Architect, follow the steps below:</span></p>
<ol style="text-indent: 0px; margin-left: 48px; list-style-position: outside;">
<li value=1><span class="f_NumberedList">In the <a href="open_a_project.htm">Open Project dialog</a>, select the </span><span class="f_MenuKeyField">Connect to Server</span><span class="f_NumberedList"> checkbox, or on the </span><span class="f_UIControl">Start Page</span><span class="f_NumberedList">, click on the </span><span class="f_MenuKeyField">Connect to Server Repository</span><span class="f_NumberedList"> link.</span></li>
<li value=2><span class="f_NumberedList">Click on the </span><span class="f_MenuKeyField">[ ... ]</span><span class="f_NumberedList"> (Browse) button, as you normally would to browse for a project. As you have selected the </span><span class="f_MenuKeyField">Connect to Server</span><span class="f_NumberedList"> checkbox, the </span><span class="f_UIControl">Data Link Properties</span><span class="f_NumberedList"> dialog displays instead of the </span><span class="f_UIControl">Browse Directories</span><span class="f_NumberedList"> dialog.</span><br>
<span class="f_NumberedList">&nbsp;</span><br>
<img src="postgredatalink-provider.png" width="356" height="429" border="0" alt="PostgreDataLink-Provider"><br>
<span class="f_NumberedList">&nbsp;</span></li>
<li value=3><span class="f_NumberedList">Select </span><span class="f_MenuKeyField">Microsoft OLE DB Provider for ODBC Drivers</span><span class="f_NumberedList"> from the list.</span></li>
<li value=4><span class="f_NumberedList">Click on the </span><span class="f_MenuKeyField">Next</span><span class="f_NumberedList"> button. The </span><span class="f_UIControl">Connection</span><span class="f_NumberedList"> tab displays.</span><br>
<span class="f_NumberedList">&nbsp;</span><br>
<img src="postgredatalink-connection.png" width="359" height="432" border="0" alt="PostgreDataLink-Connection"><br>
<span class="f_NumberedList">&nbsp;</span></li>
<li value=5><span class="f_NumberedList">Click on the </span><span class="f_MenuKeyField">Use data source name</span><span class="f_NumberedList"> drop-down arrow and, from the list, select the ODBC driver you have set up to connect to your PostgreSQL repository.</span></li>
<li value=6><span class="f_NumberedList">Click on the </span><span class="f_MenuKeyField">Test Connection</span><span class="f_NumberedList"> button to confirm that the details are correct.</span></li>
<li value=7><span class="f_NumberedList">If your test succeeded, click on the </span><span class="f_MenuKeyField">OK</span><span class="f_NumberedList"> button.</span></li>
<li value=8><span class="f_NumberedList">If your test did not succeed, revise your settings.</span></li>
<li value=9><span class="f_NumberedList">After you have clicked on the </span><span class="f_MenuKeyField">OK</span><span class="f_NumberedList"> button, the </span><span class="f_UIControl">Connection Name &amp; Type</span><span class="f_NumberedList"> dialog displays.</span><br>
<span class="f_NumberedList">&nbsp;</span><br>
<img src="postgreconnname1.png" width="287" height="327" border="0" alt="PostgreConnName1"><br>
<span class="f_NumberedList">&nbsp;</span></li>
<li value=10><span class="f_NumberedList">Give the connection a suitable name so that you can recognize it in the </span><span class="f_UIControl">Recent Projects</span><span class="f_NumberedList"> panel on the <a href="open_a_project.htm">Open Project dialog</a>.</span></li>
<li value=11><span class="f_NumberedList">If required, select the </span><span class="f_MenuKeyField">Encrypt Connection String</span><span class="f_NumberedList"> checkbox. This encrypts and hides the connection details of the database from the users that the connection string is given to.</span></li>
<li value=12><span class="f_NumberedList">If required, select the </span><span class="f_MenuKeyField">Lazy Load</span><span class="f_NumberedList"> checkbox to not load the full project view when the model is loaded. Instead, only the parts that are necessary to display the visibly portion of the tree are loaded. This means that a model loads faster and users can begin work sooner, but at the expense of later small delays as Enterprise Architect loads specific portions of the model.</span></li>
<li value=13><span class="f_NumberedList">If required, select the </span><span class="f_MenuKeyField"><a href="the_wan_optimizer.htm">Use WAN Optimization</a></span><span class="f_NumberedList"> checkbox. (To improve performance over a Wide Area Network, remote database calls can be routed through a WAN Optimizer that compresses the data returned from the repository, reducing transfer time.)</span><br>
<span class="f_NumberedList">&nbsp;</span><br>
<span class="f_NumberedList">If you select this checkbox, complete the next three fields (see your administrator for the correct values). Otherwise go to step 17.</span></li>
<li value=14><span class="f_NumberedList">In the </span><span class="f_MenuKeyField">Server</span><span class="f_NumberedList"> field, type the network name or address of the optimizer server.</span></li>
<li value=15><span class="f_NumberedList">In the </span><span class="f_MenuKeyField">Port</span><span class="f_NumberedList"> field, type the port on which the server is running on the remote machine.</span></li>
<li value=16><span class="f_NumberedList">In the </span><span class="f_MenuKeyField">DSN</span><span class="f_NumberedList"> field, type the data source name of the database as it appears on the remote machine.</span></li>
<li value=17><span class="f_NumberedList">Click on the </span><span class="f_MenuKeyField">OK</span><span class="f_NumberedList"> button to complete the configuration.</span></li>
</ol>




            </div>
          </div>
        </div>



</div>


</body>
</html>
